-
TIP - Find the date of the first Sunday of the month
This little formula is useful for a range of solutions, like working out if a date is in daylight savings time or not. The examples below reference a date field named [Date]. The first part of the fo…5 · -
Re: How to extract just the month name from a date
Nested IFs are useful when you need the full month name, but for three digit month names you can use a much simpler formula: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, …6 · -
Re: FORMULA TO PRESENT THE MONTH (NAME) IN A CELL
If you only need three digit month names the formula is much simpler: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)7 · -
Re: Month Name written as Text for Today's Date
Nested IFs are useful when you need the full month (eg. January) because they are all different lengths. But for three digit abbreviations you can use a much simpler formula: =MID("JanFebMarAprM…6 · -
Re: Formula - Return month as text from a date cell.
If you only need three digit month names the formula is much simpler: =MID("JanFebMarAprMayJunJulAugSepOctNovDec", (Mth@row * 3) - 2, 3)6 ·